using System;
using System.Data;
using common;

namespace time
{
    public class work_sql3
    {
        public static void Main()
        {
            string s = "select top 10 * from SCM.dbo.OrderDetail";
            SqlServerHelper.strConnString = @"server=PEK7-DEV-02.vancloa.cn;database=MY_SCM;uid=testdbuser;pwd=devuser221;";
            DataTable dt = SqlServerHelper.GetDataTable(s);

            foreach (DataRow row in dt.Rows)
            {
                foreach (DataColumn column in dt.Columns)
                {
                    Console.Write(row[column] + " ");
                }
            }
            Console.Read();
        }
    }
}